ALTER TABLE dbo.Event
ALTER COLUMN StartDate datetime not null

ALTER TABLE dbo.Event
ALTER COLUMN EndDate datetime not null